import pandas as pd


df = pd.read_excel(rf'D:\Desktop\mynewlearn\pandas8.xlsx',skiprows=4,usecols='H:K',index_col= None, dtype = {'sort': str, 'instore': str})




for i in df.index:
    df['sort'].at[i] = i + 1
    df['instore'].at[i] = 'no' if i % 2 == 0 else 'yes'

df = df.set_index('sort')










df.to_excel(rf'D:\Desktop\mynewlearn\pandas8-1.xlsx')

